SQL Server offers a cutting edge platform for enterprise data management, sophisticated development and implementation of modern business intelligence solutions. SQL Server 2014 offers better functionality, performance, scalability and security over previous versions. This course provides foundation the knowledge and skills to maximize the benefits of SQL Server.
Pre-requisite:
No knowledge of computer and/or IT is required to attend this program.
Training & Methodology:
Multiple training delivery methods are employed including Lectures, Demonstrations, Practical, Self Practice and workshop using real life case study with particular reference to Nigerian situations. The training is at least 80% practical.
Duration:
Weekdays :
36
hours over six (6) weeks. Three (3) hours on Tuesdays & Thursdays.
Morning : 9am. - 12p.m.
Afternoon : 2p.m. - 5p.m.
Evening : 6pm. - 8:30p.m.
Weekends :
6 hours over Three (3) months Three (3) hours each Saturday
Morning : 9am. - 12p.m.
Afternoon : 2p.m. - 5p.m.
Evening : 6pm. - 8:30p.m.
Course Contents:
The courses that are covered in this program include:
The topics that are covered in this program include:
Introduction to Microsoft SQL Server 2014
Introduction to T-SQL Querying
Writing SELECT Queries
Querying Multiple Tables
Sorting and Filtering Data
Working with SQL Server 2014 Data Types
Using DML to Modify Data
Using Built-In Functions
Grouping and Aggregating Data
Using Subqueries
Using Table Expressions
Using Set Operators
Using Window Ranking, Offset, and Aggregate Functions
Pivoting and Grouping Sets
Implementing Transactions
" I love how they train,the tutor is friendly,he makes sure you understand what he is teaching.I am very grateful, GoldTech ICT HUB is the best Computer training institute ever.GoldTech ICT HUB you are the best! "
Bakare Ajetumobi
"GoldTech
ICT HUB is a great place to be because the staffs are very social,hospitable and down to earth and our teacher was a great person to be around because he tries as much as possible to explain to the least possible detail
for easy understanding,He was very good "
Gbolahan Muktar
"The instructor was very focused and always ready to impact knowledge, GoldTech ICT HUB is a lovely place. "
Adewale Gafar
"GoldTech ICT HUB is a good organisation with well cultured workers and a very clean environment. I am impressed with the certificate in digital literacy program, the
teacher was nice, he was always ready to impact knowledge irrespective of any challenges.Thanks to all,It was a pleasure all through my days"
Rophyat Raheem
" The training was cool and we had a nice teacher who is always ready to for us, i loved the class and i am going to tell my friends at home to come for the training
"
Busola Adekunle
" The training i underwent was very interesting and i learnt alot from the teachers/instructors because they made sure we understood everything we being taught,I will
also want to use this opportunity to thank the staffs and everyone for their love and also for them to keep up the good work! "
Ibrahim Oyewole
" This training was very nice and conducive and i am so glad on how we were being treated in this training centre. More power to your elbows. "
Ifeoluwa Anuoluwapo
" Infact am so happy with this computer program, Why? because i can now operate computers and i can do alot in the office without any problems I give thanks to
the management for their understanding and cooperation "
Linda Attai
" The training conducted on certificate in digital literacy was quite okay and well delivered courtesy of the qualified and dedicated instructors in the institute. Based on
this i recommend it to all and sundry "
Segun Akerele
" It was awesome being in GoldTech ICT HUB, the tutor was competent, the students were friendly, the environment was convenient. In fact it was a wonderful experience.
"
Azeez Oladunni
" The training was very comprehensive, impactful and friendly. I will return again for further training in other areas if time and resources permit. I am more than
impressed. "
Busola Adedokun
"The teaching has been excellent and top class, the environment is conducive for learning and I don’t have any problems with the institution.” Keep it up "
Musa Kazeem
" GoldTech ICT HUB is a computer institute that helps students to really know what computer is all about with both theory and practical aspect. "
Mojeed Ajide
" The program was great one, it helped me to develop more skills about computer and how to be useful and friendly with the system. Thanks to those involved "
Ekene Menar
"Well, the training went smoothly without incident. The teaching was top class as usual and the environment was very accommodating and conducive for learning. I am
happy that I came to study here, I have gained a lot, keep up the good work."
Endurance
"My time in GoldTech ICT HUB has been well spent from our instructors to the environment, everything was well coordinated"
Eniola Ige
"Honestly, it was a very good experience, I learnt a lot of things, concerning information technology, good instructor, conducive environment for learning"
Paul Emeka
" My expectations were met in the just concluded training and my instructor helped me achieve my aims of coming for the training. "
Ifyne Ndubuisi
" They taught us in a good way for easy assimilation."
Ayorinde Tomiwa
" I am amazed,I thought i would be rushed without learning to understand but the time spent in each class was great.All i can say is that i am satisfied.
"
Okeowo Iseoluwa
Who is this course for?
Database administrators
Developers
Job Seekers
Undergraduates
Administrative Officers/Managers
Accountants working with Enterprise Resource Planning(ERP) Softwares e.g SAP SAGE etc.
Marketing/Sales Offices
Students interested in database Management
Choose from the large selection pre-made blocks - full-screen intro, bootstrap carousel, slider, responsive image gallery with, parallax scrolling, sticky header and more.